Mega Code Archive
Array
1) Accessing two dimensional Arrays
2) An array may also be updated at a single element
3) An array slice is denoted by writing lower-bound
4) An array value can be replaced completely
5) ANY function for array data type
6) ARRAY constructor syntax may also be used
7) Array Input and Output Syntax
8) Array_append(ARRAY[1,2], 3)
9) Array_cat(ARRAY[[1,2],[3,4]], ARRAY[5,6])
10) Array_cat(ARRAY[1,2], ARRAY[3,4])
11) Array_cat(ARRAY[5,6], ARRAY[[1,2],[3,4]])
12) Array_dims(1 ARRAY[2,3])
13) Array_dims(ARRAY[[1,2],[3,4]] ARRAY[[5,6],[7,8],[9,0]])
14) Array_dims(ARRAY[1,2] 3)
15) Array_dims(ARRAY[1,2] ARRAY[[3,4],[5,6]])
16) Array_dims(ARRAY[1,2] ARRAY[3,4,5])
17) Array_prepend(1, ARRAY[2,3])
18) Concatenate two arrays
19) Concatenate two dimensional arrays
20) Creating a table with a multidimensional array column
21) Creating a table with an array column
22) Define nested array
23) Insert array data to table
24) Insert data for two dimensional array
25) Insert data for two dimensional array column
26) Inserting array constants
27) Inserting values into multidimensional arrays
28) Integer array and text array
29) Modifying an array subscript
30) Reference array element
31) Searching in Arrays
32) Select array column by index
33) SELECT ARRAY[1,2] ARRAY[[3,4]] AS array
34) Selecting array values with slices
35) Selecting array values with subscripts
36) Selecting entire array values
37) Selecting From a Multi-Dimensional Array
38) Specify non-default array subscripts in an array literal
39) Two dimentional array
40) Update array value
41) Update in a slice
42) Upper and lower bound of a specified array dimension
43) Use array constant in select statement
44) Using array_dims()
45) Using the ARRAY expression syntax
46) Using two dimension array